Select Distinct Records command

Use the Select Distinct Records command to refine your report's SQL query and prevent it from returning duplicate records from the database.

When this command is enabled, SQL SELECT statements are treated as SELECT DISTINCT statements. Consequently, the query looks for identical records and ensures that they are returned only once. (To be considered identical, records must match completely—not just one or two fields.)

This command is only available for ODBC, OLE DB, and SQL native drivers; it is not available for Stored Procedures. Note also that your server may automatically sort returned values if no sort is specified in Crystal Reports.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com